﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="产品产销率情况月报表.aspx.cs" Inherits="syc.Produce.Report.产品产销率情况月报表" %>
<%@ Import Namespace="NPOI.HSSF.UserModel" %>
<%@ Import Namespace="NPOI.HPSF" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>
<html  >
<head runat="server">
    <title>产品产销率情况月报表</title>
</head>
<body>
<script runat="server">
    protected int year;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.Month0.SelectedIndex = DateTime.Today.Month - 1;
            this.Year0.Text = DateTime.Today.Year.ToString();

        }
        Button_Query_Click(null, null);
    }
    protected void WriteToFile()
    {
        DateTime d;

        d = DateTime.Today;

        Response.ContentType = "application/ms-excel";
        Response.AddHeader("content-disposition", "attachment; filename=\"" + d.ToShortDateString() + ".xls\"");
        hssfworkbook.Write(Response.OutputStream);
    }

    protected void InitializeWorkbook()
    {

        FileStream file = new FileStream(HttpContext.Current.Server.MapPath("/Produce/模板/产品产销率情况月报表.xls"), FileMode.Open, FileAccess.Read);

        hssfworkbook = new HSSFWorkbook(file);

        DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
        dsi.Company = "陕西延长石油材料有限公司";
        hssfworkbook.DocumentSummaryInformation = dsi;

        SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
        si.Subject = "报表";
        si.Title = "产品产销率情况月报表";
        hssfworkbook.SummaryInformation = si;
    }
    protected void Button_Save_Click(object sender, EventArgs e)
    {
        InitializeWorkbook();
        HSSFSheet sheet1 = hssfworkbook.GetSheet("产品产销率情况月报表");
        Button_Query_Click(null, null);
        sheet1.GetRow(1).GetCell(4).SetCellValue(DateTime.Today.Year + "年" + DateTime.Today.Month + "月");
        sheet1.GetRow(4).GetCell(1).SetCellValue(油管本期入库);
        sheet1.GetRow(4).GetCell(2).SetCellValue(油管本年累计入库);
        sheet1.GetRow(4).GetCell(3).SetCellValue(油管本期出库);
        sheet1.GetRow(4).GetCell(4).SetCellValue(油管本年累计出库);
        sheet1.GetRow(4).GetCell(5).SetCellValue(油管本月产销率.ToString("0.00"));
        sheet1.GetRow(4).GetCell(6).SetCellValue(油管本年产销率.ToString("0.00"));
        sheet1.GetRow(4).GetCell(7).SetCellValue(油管去年同期出库);
        sheet1.GetRow(4).GetCell(8).SetCellValue(油管去年同期累计出库);
        sheet1.GetRow(4).GetCell(9).SetCellValue(油管同比增长率.ToString("0.00"));
    

        sheet1.GetRow(5).GetCell(1).SetCellValue(套管本期入库);
        sheet1.GetRow(5).GetCell(2).SetCellValue(套管本年累计入库);
        sheet1.GetRow(5).GetCell(3).SetCellValue(套管本期出库);
        sheet1.GetRow(5).GetCell(4).SetCellValue(套管本年累计出库);
        sheet1.GetRow(5).GetCell(5).SetCellValue(套管本月产销率.ToString("0.00"));
        sheet1.GetRow(5).GetCell(6).SetCellValue(套管本年产销率.ToString("0.00"));
        sheet1.GetRow(5).GetCell(7).SetCellValue(套管去年同期出库);
        sheet1.GetRow(5).GetCell(8).SetCellValue(套管去年同期累计出库);
        sheet1.GetRow(5).GetCell(9).SetCellValue(套管同比增长率.ToString("0.00"));   

   

        sheet1.GetRow(6).GetCell(1).SetCellValue(油管本期入库 + 套管本期入库);
        sheet1.GetRow(6).GetCell(2).SetCellValue(油管本年累计入库 + 套管本年累计入库);
        sheet1.GetRow(6).GetCell(3).SetCellValue(油管本期出库 + 套管本期出库);
        sheet1.GetRow(6).GetCell(4).SetCellValue(油管本年累计出库 + 套管本年累计出库);
        sheet1.GetRow(6).GetCell(5).SetCellValue(本月合计产销率);
        sheet1.GetRow(6).GetCell(6).SetCellValue(全年合计累计产销率);
        sheet1.GetRow(6).GetCell(7).SetCellValue(油管去年同期出库 + 套管去年同期出库);
        sheet1.GetRow(6).GetCell(8).SetCellValue(油管去年同期累计出库 + 套管去年同期累计出库);
        sheet1.GetRow(6).GetCell(9).SetCellValue(油套管同比增长率.ToString("0.00"));

        sheet1.GetRow(20).GetCell(9).SetCellValue("报出日期：" + DateTime.Today.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day);  
        WriteToFile();
        Response.End();
    }

    protected void Button_Query_Click(object sender, EventArgs e)
    {
        year = int.Parse(this.Year0.Text);
        SqlConnection Conn = new SqlConnection();
        Conn.ConnectionString = ConfigurationManager.ConnectionStrings["SCMConnectionString1"].ConnectionString;
        try
        {
            Conn.Open();
            SqlCommand Cmd = new SqlCommand();
            Cmd.Connection = Conn;
            string sql1 = "select dbo.产品本月实际产量(*年份*,*月份*,1),dbo.产品本月实际产量(*年份*,*月份*,2),dbo.产品本月实际产量(*年份*,*月份*,6)";
            sql1 = sql1.Replace("*年份*", year.ToString());
            sql1 = sql1.Replace("*月份*", this.Month0.Text.ToString());
            Cmd.CommandText = sql1;
            SqlDataReader Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                油管本期入库 = double.Parse(Reader.GetDecimal(0).ToString());
                套管本期入库 = double.Parse(Reader.GetDecimal(1).ToString()) + double.Parse(Reader.GetDecimal(2).ToString());                
            }
            Reader.Close();
            string sql2 = "select dbo.产品某月止累计(*年份*,*月份*,1),dbo.产品某月止累计(*年份*,*月份*,2),dbo.产品某月止累计(*年份*,*月份*,6)";
            sql2 = sql2.Replace("*年份*", year.ToString());
            sql2 = sql2.Replace("*月份*", this.Month0.Text.ToString());
            Cmd.CommandText = sql2;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                油管本年累计入库 = double.Parse(Reader.GetDecimal(0).ToString());
                套管本年累计入库 = double.Parse(Reader.GetDecimal(1).ToString()) + double.Parse(Reader.GetDecimal(2).ToString());            }
            Reader.Close();
            string sql3 = "select dbo.[产品本期发出](*年份*,*月份*,1,0),dbo.[产品本期发出](*年份*,*月份*,2,0),dbo.[产品本期发出](*年份*,*月份*,4,0)";
            sql3 = sql3.Replace("*年份*", year.ToString());
            sql3 = sql3.Replace("*月份*", this.Month0.Text.ToString());
            Cmd.CommandText = sql3;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                油管本期出库 = Reader.GetDouble(0);
                套管本期出库 = Reader.GetDouble(1) + Reader.GetDouble(2);               
            }
            Reader.Close();
            string sql4 = "select dbo.[产品本期发出累计](*年份*,*月份*,1,0),dbo.[产品本期发出累计](*年份*,*月份*,2,0),dbo.[产品本期发出累计](*年份*,*月份*,4,0)";
            sql4 = sql4.Replace("*年份*", year.ToString());
            sql4 = sql4.Replace("*月份*", this.Month0.Text.ToString());
            Cmd.CommandText = sql4;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                油管本年累计出库 = Reader.GetDouble(0);
                套管本年累计出库 = Reader.GetDouble(1) +  Reader.GetDouble(2);
                
            }
            Reader.Close();
            string sql5 = "select dbo.[产品本期发出](*年份*,*月份*,1,0),dbo.[产品本期发出](*年份*,*月份*,2,0),dbo.[产品本期发出](*年份*,*月份*,4,0)";
            sql5 = sql5.Replace("*年份*", (year - 1).ToString());
            sql5 = sql5.Replace("*月份*", this.Month0.Text.ToString());
            Cmd.CommandText = sql5;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                油管去年同期出库 = Reader.GetDouble(0);
                套管去年同期出库 = Reader.GetDouble(1) + Reader.GetDouble(2);               
            }
            Reader.Close();
            string sql6 = "select dbo.[产品本期发出累计](*年份*,*月份*,1,0),dbo.[产品本期发出累计](*年份*,*月份*,2,0),dbo.[产品本期发出累计](*年份*,*月份*,4,0)";
            sql6 = sql6.Replace("*年份*", (year - 1).ToString());
            sql6 = sql6.Replace("*月份*", this.Month0.Text.ToString());
            Cmd.CommandText = sql6;
            Reader = Cmd.ExecuteReader();
            if (Reader.Read())
            {
                油管去年同期累计出库 = Reader.GetDouble(0);
                套管去年同期累计出库 = Reader.GetDouble(1) + Reader.GetDouble(2);             
            }
            Reader.Close();
        }
        catch (Exception ex)
        {
            Conn.Close();
            return;
            throw ex;
        }
        finally
        {
            Conn.Close();
            Conn.Dispose();
        }
        if (油管本期入库 == 0)
        {
            油管本月产销率 = 0;
        }
        else
        {
            油管本月产销率 = (油管本期出库 / 油管本期入库) * 100;
        }
        if (套管本期入库 == 0)
        {
            套管本月产销率 = 0;
        }
        else
        {
            套管本月产销率 = (套管本期出库 / 套管本期入库) * 100;
        }
  
        if (油管本年累计入库 == 0)
        {
            油管本年产销率 = 0;
        }
        else
        {
            油管本年产销率 = (油管本年累计出库 / 油管本年累计入库) * 100;
        }
        if (套管本年累计入库 == 0)
        {
            套管本年产销率 = 0;
        }
        else
        {
            套管本年产销率 = (套管本年累计出库 / 套管本年累计入库) * 100;
        }
        if (油管本期入库 + 套管本期入库 == 0)
        {
            本月合计产销率 = "0";
        }
        else
        {
            本月合计产销率 = (((油管本期出库 + 套管本期出库) / (油管本期入库 + 套管本期入库)) * 100).ToString("0.00");
        }
        if (油管本年累计入库 + 套管本年累计入库 == 0)
        {
            全年合计累计产销率 = "0";
        }
        else
        {
            全年合计累计产销率 = (((油管本年累计出库 + 套管本年累计出库) / (油管本年累计入库 + 套管本年累计入库)) * 100).ToString("0.00");
        }
        if(油管去年同期累计出库==0)
        {
            油管同比增长率=0;
        }else
        {
            油管同比增长率=((油管本年累计出库/油管去年同期累计出库)-1)*100;
        }
        if (套管去年同期累计出库 == 0)
        {
            套管同比增长率 = 0;
        }
        else
        {
            套管同比增长率=((套管本年累计出库/套管去年同期累计出库)-1)*100;
        }
        if ((油管去年同期累计出库 + 套管去年同期累计出库) == 0)
        {
           油套管同比增长率 = 0;
        }
        else
        {
            油套管同比增长率 = (((油管本年累计出库 + 套管本年累计出库) / (油管去年同期累计出库 + 套管去年同期累计出库)) - 1) * 100;
        }
    }

    protected void Year0_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    protected void Month0_SelectedIndexChanged(object sender, EventArgs e)
    {

    }       
</script>
     <script type="text/javascript" language="javascript" src="/common.js"></script>
    <form id="form1" runat="server">
    <asp:Panel ID="Panel3" runat="server" CssClass="panel">
     年份：<asp:DropDownList ID="Year0" runat="server" AutoPostBack="true" 
            onselectedindexchanged="Year0_SelectedIndexChanged">
            <asp:ListItem>2009</asp:ListItem>
            <asp:ListItem>2010</asp:ListItem>
            <asp:ListItem>2011</asp:ListItem>
            <asp:ListItem>2012</asp:ListItem>
            <asp:ListItem>2013</asp:ListItem>
            <asp:ListItem>2014</asp:ListItem>
            <asp:ListItem>2015</asp:ListItem>           
            </asp:DropDownList>
     <span lang="zh-cn">&nbsp;&nbsp;&nbsp; 月份：</span><asp:DropDownList ID="Month0" runat="server" 
                AutoPostBack="true" 
            onselectedindexchanged="Month0_SelectedIndexChanged">
                <asp:ListItem Value=1>1</asp:ListItem>
                <asp:ListItem Value=2>2</asp:ListItem>
                <asp:ListItem Value=3>3</asp:ListItem>
                <asp:ListItem Value=4>4</asp:ListItem>
                <asp:ListItem Value=5>5</asp:ListItem>
                <asp:ListItem Value=6>6</asp:ListItem>
                <asp:ListItem Value=7>7</asp:ListItem>
                <asp:ListItem Value=8>8</asp:ListItem>
                <asp:ListItem Value=9>9</asp:ListItem>
                <asp:ListItem Value=10>10</asp:ListItem>
                <asp:ListItem Value=11>11</asp:ListItem>
                <asp:ListItem Value=12>12</asp:ListItem>
            </asp:DropDownList>          
            月&nbsp;&nbsp;&nbsp;
     <asp:Button ID="Button_Query"
            runat="server" Text="查看报表" CssClass="button" UseSubmitBehavior="true" onclick="Button_Query_Click"  Visible="false"
             />
            <asp:Button ID="Button_Save" runat="server" Text="导出报表" CssClass="button" 
                UseSubmitBehavior="False" onclick="Button_Save_Click"/>
    </asp:Panel>
    <asp:Panel ID="Panel2" runat="server" CssClass="panel2">
        <asp:Label ID="Message" runat="server" Text="·准备就绪" CssClass="prompt"></asp:Label>
    </asp:Panel>
    <div align="center">
   <style>
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
@page
	{margin:.59in .41in 1.0in .65in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-page-orientation:landscape;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
.style17
	{mso-number-format:"_ \0022\00A5\0022* \#\,\#\#0\.00_ \;_ \0022\00A5\0022* \\-\#\,\#\#0\.00_ \;_ \0022\00A5\0022* \0022-\0022??_ \;_ \@_ ";
	mso-style-name:货币;
	mso-style-id:4;}
.style21
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:\3F3F\3F3F\3F3F\3F3F?    ;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl26
	{mso-style-parent:style21;
	font-size:10.0pt;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl27
	{mso-style-parent:style21;
	font-size:11.0pt;
	text-align:center;
	border:.5pt solid windowtext;}
.xl28
	{mso-style-parent:style21;
	font-size:11.0pt;
	border:.5pt solid windowtext;}
.xl29
	{mso-style-parent:style21;
	font-size:10.0pt;}
.xl30
	{mso-style-parent:style21;
	font-size:10.0pt;
	text-align:center;
	border:.5pt solid windowtext;}
.xl31
	{mso-style-parent:style0;
	text-align:center;}
.xl32
	{mso-style-parent:style21;
	font-size:10.0pt;
	text-align:left;
	border:.5pt solid windowtext;}
.xl33
	{mso-style-parent:style21;
	font-size:10.0pt;
	border:.5pt solid windowtext;}
.xl34
	{mso-style-parent:style0;
	font-size:10.0pt;}
.xl35
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;}
.xl36
	{mso-style-parent:style0;
	font-size:11.0pt;
	text-align:center;}
.xl37
	{mso-style-parent:style17;
	font-size:10.0pt;
	mso-number-format:"_ \0022\00A5\0022* \#\,\#\#0\.00_ \;_ \0022\00A5\0022* \\-\#\,\#\#0\.00_ \;_ \0022\00A5\0022* \0022-\0022??_ \;_ \@_ ";
	text-align:center;
	border:.5pt solid windowtext;
	white-space:normal;}
.xl38
	{mso-style-parent:style17;
	font-size:10.0pt;
	mso-number-format:"_ \0022\00A5\0022* \#\,\#\#0\.00_ \;_ \0022\00A5\0022* \\-\#\,\#\#0\.00_ \;_ \0022\00A5\0022* \0022-\0022??_ \;_ \@_ ";
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl39
	{mso-style-parent:style21;
	font-size:10.0pt;
	mso-number-format:"0\.00_ ";
	text-align:center;
	border:.5pt solid windowtext;}
.xl40
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;}
.xl41
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border:.5pt solid windowtext;}
.xl42
	{mso-style-parent:style21;
	font-size:18.0pt;
	font-weight:700;
	text-align:center;}
.xl43
	{mso-style-parent:style21;
	font-size:10.0pt;
	mso-number-format:"yyyy\0022年\0022m\0022月\0022";
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl44
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;}
.xl45
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;}
.xl46
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;}
.xl47
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl48
	{mso-style-parent:style0;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl49
	{mso-style-parent:style21;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl50
	{mso-style-parent:style21;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl51
	{mso-style-parent:style21;
	font-size:10.0pt;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:none;
	border-left:none;
	white-space:normal;}
.xl52
	{mso-style-parent:style21;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	white-space:normal;}
.xl53
	{mso-style-parent:style21;
	font-size:10.0pt;
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	white-space:normal;}
.xl54
	{mso-style-parent:style21;
	font-size:10.0pt;
	mso-number-format:"0\.000\;\[Red\]0\.000";
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;}
.xl55
	{mso-style-parent:style21;
	font-size:10.0pt;
	mso-number-format:"0\.000\;\[Red\]0\.000";
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>产品产销率情况月报表</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:HorizontalResolution>200</x:HorizontalResolution>
      <x:VerticalResolution>200</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:TopRowVisible>9</x:TopRowVisible>
     <x:LeftColumnVisible>1</x:LeftColumnVisible>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>4</x:ActiveRow>
       <x:ActiveCol>11</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet2</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
   <x:ExcelWorksheet>
    <x:Name>Sheet3</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>9225</x:WindowHeight>
  <x:WindowWidth>11700</x:WindowWidth>
  <x:WindowTopX>240</x:WindowTopX>
  <x:WindowTopY>105</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<body link=blue vlink=purple>

<table x:str border=0 cellpadding=0 cellspacing=0 width=1750 style='border-collapse:
 collapse;table-layout:fixed;width:1314pt'>
 <col width=84 span=2 style='mso-width-source:userset;mso-width-alt:2688;
 width:63pt'>
 <col width=90 style='mso-width-source:userset;mso-width-alt:2880;width:68pt'>
 <col width=88 style='mso-width-source:userset;mso-width-alt:2816;width:66pt'>
 <col width=90 style='mso-width-source:userset;mso-width-alt:2880;width:68pt'>
 <col width=82 style='mso-width-source:userset;mso-width-alt:2624;width:62pt'>
 <col width=90 style='mso-width-source:userset;mso-width-alt:2880;width:68pt'>
 <col width=103 style='mso-width-source:userset;mso-width-alt:3296;width:77pt'>
 <col width=104 style='mso-width-source:userset;mso-width-alt:3328;width:78pt'>
 <col width=95 style='mso-width-source:userset;mso-width-alt:3040;width:71pt'>
 <col width=48 style='mso-width-source:userset;mso-width-alt:1536;width:36pt'>
 <col width=72 span=11 style='width:54pt'>
 <tr height=48 style='mso-height-source:userset;height:36.0pt'>
  <td colspan=11 height=48 class=xl42 width=958 style='height:36.0pt;
  width:720pt'>产品产、销率情况月报表</td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td height=19 class=xl26 style='height:14.25pt' colspan=3>填报单位：陕西石油材料有限责任公司</td> 
  <td></td>
  <td colspan=3 class=xl43><%=this.Year0.Text %>年<%=this.Month0.Text %>月</td>
  <td colspan=2 class=xl48>单位:吨、%</td>
  <td colspan=2 class=xl49>陕油统<span style='mso-spacerun:yes'>&nbsp;
  </span>材料厂B－1505</td>
  <td colspan=11 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=26 style='mso-height-source:userset;height:19.5pt'>
  <td rowspan=2 height=49 class=xl37 width=84 style='height:36.75pt;border-top:
  none;width:63pt' x:str="产品名称"><span
  style='mso-spacerun:yes'>&nbsp;</span>产品名称<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td colspan=2 class=xl30 style='border-left:none'>购进量或交货量</td>
  <td colspan=2 class=xl41 style='border-left:none'>发货量</td>
  <td colspan=2 class=xl44 style='border-right:.5pt solid black;border-left:
  none'>产销率</td>
  <td colspan=2 class=xl46 style='border-left:none'>去年同期发货量</td>
  <td colspan=2 rowspan=2 class=xl50 width=143 style='border-right:.5pt solid black;
  border-bottom:.5pt solid black;width:107pt'>同比增长率</td>
  <td colspan=11 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=23 style='mso-height-source:userset;height:17.25pt'>
  <td height=23 class=xl37 width=84 style='height:17.25pt;border-top:none;
  border-left:none;width:63pt' x:str="本月"><span
  style='mso-spacerun:yes'>&nbsp;</span>本月<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl38 width=90 style='width:68pt' x:str="累计"><span
  style='mso-spacerun:yes'>&nbsp;</span>累计<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl37 width=88 style='border-top:none;border-left:none;width:66pt'
  x:str="本月"><span style='mso-spacerun:yes'>&nbsp;</span>本月<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl38 width=90 style='width:68pt' x:str="累计"><span
  style='mso-spacerun:yes'>&nbsp;</span>累计<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl37 width=82 style='border-left:none;width:62pt' x:str="本月"><span
  style='mso-spacerun:yes'>&nbsp;</span>本月<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl37 width=90 style='border-left:none;width:68pt' x:str="累计"><span
  style='mso-spacerun:yes'>&nbsp;</span>累计<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl37 width=103 style='border-top:none;border-left:none;width:77pt'
  x:str="本月"><span style='mso-spacerun:yes'>&nbsp;</span>本月<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td class=xl38 width=104 style='width:78pt' x:str="累计"><span
  style='mso-spacerun:yes'>&nbsp;</span>累计<span
  style='mso-spacerun:yes'>&nbsp;</span></td>
  <td colspan=11 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>油管</td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本期入库 %></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本年累计入库 %></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本期出库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本年累计出库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本月产销率.ToString("0.00") %></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本年产销率.ToString("0.00")%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管去年同期出库 %></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管去年同期累计出库 %></td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'><%=油管同比增长率 %></td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>套管</td>
  <td class=xl30 style='border-top:none;border-left:none'><%=套管本期入库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=套管本年累计入库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=套管本期出库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=套管本年累计出库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=套管本月产销率.ToString("0.00")%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=套管本年产销率.ToString("0.00")%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=套管去年同期出库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=套管去年同期累计出库%></td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'><%=套管同比增长率 %></td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl30 style='height:18.95pt;border-top:none'>合计</td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本期入库 + 套管本期入库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本年累计入库 + 套管本年累计入库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本期出库 + 套管本期出库%></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管本年累计出库 + 套管本年累计出库%></td>
  <td class=xl39 style='border-top:none;border-left:none'><%=本月合计产销率 %></td>
  <td class=xl39 style='border-top:none;border-left:none'><%=全年合计累计产销率%>　</td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管去年同期出库 + 套管去年同期出库 %></td>
  <td class=xl30 style='border-top:none;border-left:none'><%=油管去年同期累计出库 + 套管去年同期累计出库%></td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'><%=油套管同比增长率 %></td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl32 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl33 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td class=xl30 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td class=xl35></td>
  <td colspan=10 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl28 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td colspan=11 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=25 style='mso-height-source:userset;height:18.95pt'>
  <td height=25 class=xl28 style='height:18.95pt;border-top:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td class=xl27 style='border-top:none;border-left:none'>　</td>
  <td colspan=2 class=xl54 style='border-right:.5pt solid black;border-left:
  none'>　</td>
  <td colspan=11 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl34 colspan=2 style='height:22.5pt;mso-ignore:colspan'>主管领导：焦平</td>
  <td></td>
  <td class=xl35>统计负责人：</td>
  <td class=xl35>廉宝仁</td>
  <td class=xl36></td>
  <td class=xl35 colspan="2">填报人：谷立凤</td>
  <td></td>
  <td colspan=2 class=xl40>报出日期：<%=DateTime.Now.ToString("yyyy-MM-dd") %></td>
  <td colspan=11 class=xl31 style='mso-ignore:colspan'></td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=84 style='width:63pt'></td>
  <td width=84 style='width:63pt'></td>
  <td width=90 style='width:68pt'></td>
  <td width=88 style='width:66pt'></td>
  <td width=90 style='width:68pt'></td>
  <td width=82 style='width:62pt'></td>
  <td width=90 style='width:68pt'></td>
  <td width=103 style='width:77pt'></td>
  <td width=104 style='width:78pt'></td>
  <td width=95 style='width:71pt'></td>
  <td width=48 style='width:36pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=72 style='width:54pt'></td>
 </tr>
 <![endif]>
</table>
    </div>
    </form>
    <script>        parent.hidesubmenu(true);</script>
</body>
</html>
